/********************************************************************
Copyright by PCI, 2002-10-08
File Name: db_ppm_mdse_count_his.cxx
Created Date: 2002-10-08 
Author: Machine
Version: 1.0 
Last Version Date: 
Version Date:
*******************************************************************/
/********************************************************************
Copyright by PCI, 2002-10-08
Class Name: CTable_PPM_MDSE_COUNT_HIS
Created Date: 2002-10-08 
Author: Machine
Defined File: db_ppm_mdse_count_his.hxx
Last Version Date: 
Version Date:
*******************************************************************/
#include "app97_global.h" 
#include "table_ppm.h"

CTable_PPM_MDSE_COUNT_HIS::CTable_PPM_MDSE_COUNT_HIS( )
:NPCRecordSet( )
{
  setTableName( "PPM_MDSE_COUNT_HIS" );
  prepareTable();
  prepareQuery();
  
  HIS_ID.setField( "HIS_ID", DATA_CHAR, 20, 1 );
  makeTableItem( HIS_ID );
  makeKeyItem( HIS_ID ); 
  ID.setField( "ID", DATA_CHAR, 20, 0 );
  makeTableItem( ID );
  OFFER_NBR.setField( "OFFER_NBR", DATA_CHAR, 20, 0 );
  makeTableItem( OFFER_NBR );
  OFFER_NAME.setField( "OFFER_NAME", DATA_CHAR, 512, 0 );
  makeTableItem( OFFER_NAME );
  INCOME.setField( "INCOME", DATA_CHAR, 20, 0 );
  makeTableItem( INCOME );
  USER_NUM.setField( "USER_NUM", DATA_CHAR, 20, 0 );
  makeTableItem( USER_NUM );
  COUNT_DATE.setField( "COUNT_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( COUNT_DATE );
  STATE.setField( "STATE", DATA_CHAR, 6, 0 );
  makeTableItem( STATE );
  STATEDATE.setField( "STATEDATE", DATA_DATETIME, 7, 0 );
  makeTableItem( STATEDATE );
  STAFF.setField( "STAFF", DATA_CHAR, 6, 0 );
  makeTableItem( STAFF );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  MODIFY_DATE.setField( "MODIFY_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( MODIFY_DATE );
  REMARK.setField( "REMARK", DATA_CHAR, 512, 0 );
  makeTableItem( REMARK );
}


CTable_PPM_MDSE_COUNT_HIS::CTable_PPM_MDSE_COUNT_HIS( NPConnection& pcldb )
:NPCRecordSet( pcldb )
{
  setTableName( "PPM_MDSE_COUNT_HIS" );
  prepareTable();
  prepareQuery();
  
  HIS_ID.setField( "HIS_ID", DATA_CHAR, 20, 1 );
  makeTableItem( HIS_ID );
  makeKeyItem( HIS_ID ); 
  ID.setField( "ID", DATA_CHAR, 20, 0 );
  makeTableItem( ID );
  OFFER_NBR.setField( "OFFER_NBR", DATA_CHAR, 20, 0 );
  makeTableItem( OFFER_NBR );
  OFFER_NAME.setField( "OFFER_NAME", DATA_CHAR, 512, 0 );
  makeTableItem( OFFER_NAME );
  INCOME.setField( "INCOME", DATA_CHAR, 20, 0 );
  makeTableItem( INCOME );
  USER_NUM.setField( "USER_NUM", DATA_CHAR, 20, 0 );
  makeTableItem( USER_NUM );
  COUNT_DATE.setField( "COUNT_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( COUNT_DATE );
  STATE.setField( "STATE", DATA_CHAR, 6, 0 );
  makeTableItem( STATE );
  STATEDATE.setField( "STATEDATE", DATA_DATETIME, 7, 0 );
  makeTableItem( STATEDATE );
  STAFF.setField( "STAFF", DATA_CHAR, 6, 0 );
  makeTableItem( STAFF );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  MODIFY_DATE.setField( "MODIFY_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( MODIFY_DATE );
  REMARK.setField( "REMARK", DATA_CHAR, 512, 0 );
  makeTableItem( REMARK );
}

CTable_PPM_MDSE_COUNT_HIS::~CTable_PPM_MDSE_COUNT_HIS( )
{
  close();
}

